EMT Practice Test

1. Question Content...

---

Question1: You have the following dataset:

Which grouping option should you use in Tableau Prep to group all five names automatically?

Question2: You have the following chart that shows profits and discounts over time.

You need to combine the lines to appear as shown in the following chart.

What should you do?

Question3: You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?

Question4: You have the following dataset.


When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.

What should you do?

Question5: You have a dataset that contains people and the awards they have won.

Which formula should you use to get the number of different types of awards that have been won?

Question6: You have the following dataset in Microsoft Excel.

You are using Data interpreter to cleans the dataset. Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

Question7: You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.
What should you do?

Question8: You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

Question9: You are creating a new dashboard.
You need to add a button to the dashboard that allows users to export the dashboard as an image.
Which type of object should you use?

Question10: You have a dataset that contains people and the awards they have won.

Which formula should you use to get the number of different types of awards that have been won?

Question11: You have the following dataset.

Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

Question12: Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.

Question13: You are the owner of an alert.
You receive an email notification that the alert was suspended
From where can you resume the suspended alert?

Question14: You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?

Question15: You have a dashboard that is configured for desktop browsers.
You want to customize a layout for mobile users.
Which option should you select first? (Click the appropriate Option in the Answer Area.)

Question16: You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

Question17: Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.

Question18: You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

Question19: You have a dataset that contains sates data. The following is a sample of the data.

You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two

Question20: You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.
To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)

Question21: You have the following visualization.

Question22: You have the following worksheet.

You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Question23: You have the following line chart that shows the average sales by month.

Which month had the biggest increase in swage sales compared to me previous month in 2019?

Question24: You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.

You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.

Question25: From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?

Question26: You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?

Question27: You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data''

Question28: You have the following visualization.

You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Question29: You have the following table.

You need each record to alternate between grey and white.
What should you change in the Format Shading pane?

Question30: You have the following dashboard that contains two sheets.

You want to minimize the whitespace between the sheets.
What should you configure?

Question31: Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.

Question32: A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?

Question33: In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?

Question34: You have the following primary data source that contains a dimension named Dorm_Code.

You receive the following secondary data source that contains updated dorm codes.

You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?

Question35: You want to create the following table in a view.

Which function should you use to create the Position column?

Question36: You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?

Question37: You have the following Map.

You need the map to appear as shown in the following visualization.

What should you do?

Question38: You create the following worksheet

The Pick Measure parameter contains the following list of values

Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the Selected Measure calculated field lo switch between measures?

Question39: You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform in order? (Place the three correct options in order.)

Question40: Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.

Question41: You have the following visualization.

You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.
What is the Rank Score value for Student ID 4220?

Question42: You are developing a data source in Tableau Prep.
You have two tables named Orders and Employees.
The Orders table was created in 2019 and contains the following columns.

The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns

You want to prepare the data so that you can analyze sales trends over time for every sales team.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area. Use Answer Area arrows to re-order the options.)

Question43: You have the following dataset.

You need to create the following worksheet.

The table must show either profit or sales based on the selection from the Parameter 1 menu.
Which three actions should you perform in orders
(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

Question44: You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

Question45: You want to create the following dashboard.

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

Question46: Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

Question47: You have the following dataset

You need to create the following visualization.

Which quick table calculation should you drag to Text on the Marks card?